SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104945 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104945 [ RunTime:0.003105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128750,378437,187708,886987,881467,1007255,693372,225894,923732,67601,58453,493326,399816,535137,441393,318694,556576,81295,788386,789453,528845,389343,969794,669538,170433,549507,442585,1039014,592485,718144,658190,1022156,1042015,227958,89791,398296,127162,548825,418470,94111,649347,556348,1002417,872545,814773,391449,647278,1015843,327410,243617,1048113,756258,900885,870684,714087,117129,234815,995143,378355,413816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]