SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643106 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643106 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150141,598144,560702,42381,338961,191071,521240,608185,1045815,466412,483008,581166,826978,311165,646238,71950,930307,619859,656599,395393,827717,508091,864480,196586,66672,449360,520787,984406,289018,282914,127986,1034880,574651,118992,893157,83165,332849,610897,454032,589863,403302,151978,280351,365887,1005994,916539,135964,127394,688520,1009230,422847,921886,26466,295715,250300,82492,297525,738071,673538,603138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]