SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48843 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48843 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946633,505343,366620,477843,391047,904734,229531,585308,37040,551568,188342,381585,423419,531817,194047,809703,825496,692780,485933,573405,136702,210259,527949,292995,666797,258906,1038039,744127,577812,593830,119286,648187,102664,270640,606383,319370,329276,785562,713605,16922,254280,63151,301629,137228,203785,384848,879052,23145,88877,272751,525378,854974,729226,631245,787471,325532,687248,954357,449100,636186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]