SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 660314 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 660314 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904316,131212,205604,588952,766524,938429,933999,592765,831909,928646,894388,369103,557429,136,509596,401823,522337,123646,527945,797995,202222,230465,369834,126907,285733,974010,138387,606974,73705,346970,954651,662925,1045879,311114,673270,439341,716928,207482,165981,759060,833480,521709,309524,61214,699682,368936,845626,290631,291376,753122,855619,628434,452889,42120,783521,851574,555094,133506,840412,560048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 660314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 660314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]