SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 623509 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 623509 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321978,960662,1008052,434859,416014,996090,605756,805086,875462,419162,627957,854207,294962,826167,981825,104203,449641,161400,612941,974124,779112,41647,931643,140544,623737,872025,1017321,197276,131112,537948,163034,597080,109710,945216,467651,804238,104554,1009026,378544,142669,794958,263888,22545,945723,781789,217997,831061,250244,523274,1021099,634871,279236,968712,914918,222931,752255,117779,879128,844006,559628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 623509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 623509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]