SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105028 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105028 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360900,582273,735513,507201,286803,817554,214331,525809,310153,30052,668873,623899,613851,408825,407293,952570,74888,157276,371147,837950,772010,910700,878289,436795,422754,542086,702501,37615,111698,250548,616576,179009,1021908,266643,325074,76876,68689,182362,424460,284321,547043,388724,580703,338253,878414,44558,220674,313478,410330,618392,470976,241872,573296,921349,41734,440075,833042,778747,652361,157301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]