SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476505 LIMIT 1 [ RunTime:0.000651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476505 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671348,520357,1048338,52280,900638,21650,852284,314700,611183,674395,908144,920663,426765,124158,177086,1027088,770148,938394,378398,1038589,324961,198684,809473,180317,256634,896815,913365,298660,639070,265119,385945,416801,649770,206784,556545,813053,87477,958559,280815,807951,649720,829501,683598,435801,322082,458878,605742,550489,280400,985534,257199,970404,887201,102277,206359,519725,307936,47394,211472,697553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]