SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289711 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289711 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622739,180463,301172,610802,893092,373618,1038858,702933,878947,874562,49008,670584,864848,52960,400131,279500,139406,102818,838913,144739,963735,485733,975340,1000727,179197,661471,43680,1023,901691,345484,662623,435500,315968,571529,971173,807062,868185,514830,1028362,885540,471242,775875,652187,52097,557338,458565,311235,548884,773144,988862,782518,410844,360368,549392,606556,553364,271460,260807,849367,722430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]