SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465723 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465723 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38241,8584,510658,183833,599608,245416,111931,94291,88748,174041,389302,173436,503859,423790,98833,265950,838410,259145,780347,927567,778764,716751,803768,84723,656171,1011445,519103,65348,864819,456183,10497,21590,149867,319190,983316,363124,841513,1020114,37640,795449,308849,886234,997085,187951,620190,1018410,706891,1000311,386407,118128,289485,1017487,208007,440339,664933,445004,142113,406277,369604,173811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]