SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546054 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546054 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691624,822553,691326,135758,138997,976392,885921,373815,698748,73631,334661,708014,579152,873613,463928,510230,682929,78383,739775,137012,677219,221561,382328,453317,323754,810039,64238,335518,896440,642347,369863,619971,319070,604440,1021506,950330,370208,977476,269456,138326,3211,146765,327385,751259,555275,64194,66142,431880,306502,402757,933293,861641,490740,733945,1005614,626286,602695,854159,434842,245911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]