SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418038 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418038 [ RunTime:0.003215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130478,14995,1006111,961398,391572,255926,483162,894103,277280,960819,898750,110058,479739,183106,946854,82848,283315,11765,765204,617397,789800,184819,60315,762270,27933,892484,701323,927571,1031673,467631,605011,901167,829169,764534,808860,108575,60416,975605,467221,818023,412563,694114,87513,749624,242893,929267,531109,220417,463998,944073,324021,529307,545273,724214,51504,873556,206798,991927,922429,386619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]