SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681150 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681150 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212648,789958,704724,461367,952035,308140,506588,784765,564761,166604,926076,459817,857494,883377,859063,933892,120340,122089,457011,147575,928803,638259,315620,120448,1022247,123545,656336,938388,226777,930834,145408,901272,328072,355615,28277,203415,507169,942046,759385,52221,941343,1033060,491846,602936,255483,737782,868439,94636,280168,570307,110688,827638,54313,11976,933590,555067,73174,112740,609304,37056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]