SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341795 LIMIT 1 [ RunTime:0.000712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341795 [ RunTime:0.003454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475652,300918,683502,59101,788064,344600,573207,146515,112857,672543,1046147,516409,613752,696518,831319,840018,739140,472704,766852,513407,20161,515416,990462,177457,359916,432662,813076,65581,827319,289319,888927,530230,690149,953209,200115,481300,49373,695348,740781,848160,222025,879882,222983,561749,1001124,1040569,74032,458622,55975,975330,727282,89132,83342,752068,720204,726678,271697,554580,369870,806772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001776s ]