SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289073 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289073 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977712,307326,136162,508065,280153,829880,678202,876416,1000697,394003,680125,312880,904453,1019324,1002477,759145,305433,519965,595565,234643,707257,316582,336941,456540,696767,50930,907766,643759,862664,781079,13546,130739,808518,641359,980508,551434,477704,368440,768250,877003,232256,639169,1033207,548296,973205,557448,1004617,759983,879840,191967,763660,473432,964002,974651,572524,369763,329613,1048419,211553,32719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]