SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 558084 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 558084 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202798,4011,16317,118495,897101,194744,1009093,511437,475530,356586,842755,843601,68691,11883,29930,204902,713235,116128,917408,802473,194114,404789,950796,1001501,52722,622122,1026665,1022226,130228,1007745,165987,15656,989994,155541,121979,1045450,753718,647184,272931,696623,198252,418320,626072,935333,593347,42017,936347,255478,68611,561364,473057,764232,120330,400107,932173,942011,653546,947613,692414,80289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 558084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 558084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]