SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197582 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197582 [ RunTime:0.003356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105188,759204,784244,234515,387835,306793,541658,39780,281173,195063,311648,1016382,262916,745970,57803,106276,595633,760121,619068,317971,737948,861401,655434,518734,83317,528753,520177,758765,407586,377734,513882,96581,545052,904850,778216,479160,198954,803766,613266,765124,526902,949590,975415,799426,684294,663542,751770,483516,498084,778553,610832,509572,201672,652779,68867,584655,376188,398994,307325,754110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]