SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517993 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517993 [ RunTime:0.004678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324342,545831,232826,1007085,510036,1032623,732731,1003810,566608,867851,710386,92136,831178,817692,713351,524533,179850,949874,578244,621140,752362,922085,204234,457842,33896,676604,576196,745597,123843,250941,826195,415172,16034,161275,399060,772105,812022,833549,402374,826706,834251,633987,901677,806488,41439,839870,173959,134732,549712,1025661,198806,967970,658786,650906,627700,542374,1043850,729023,104372,942962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]