SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22643 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22643 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806195,242099,399868,463982,742313,290787,770561,1026874,806778,392216,80153,1030910,733036,345600,295140,751368,446059,1006717,851810,306161,780228,478687,335210,961867,271510,188128,220263,883623,365787,782072,953308,468501,683116,860909,823781,484121,572920,752934,839692,646945,656575,740505,401256,469856,112198,235929,961910,940936,632975,1016434,1027769,508152,488223,236125,27970,731844,580782,116767,134718,252736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]