SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148787 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148787 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121789,201344,1012001,1011723,299953,1039032,954314,334786,814682,349031,8144,933605,886598,195081,617476,638226,899889,908795,639858,639337,1016286,510097,460471,486138,150645,545942,118218,805647,313472,688918,480898,446056,676206,102427,1029520,324300,1004077,370407,197189,948135,305433,548785,377134,237395,7236,545992,1036291,542084,990556,106168,731164,651075,795632,874187,430161,958452,329914,811295,313628,807320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]