SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404581 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404581 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171438,1024385,839104,792719,801299,614884,820174,652949,354708,582107,425999,517955,171605,708965,40860,958023,345921,225084,870214,988590,173642,53126,746533,1071,196141,79962,345433,641528,881153,256273,44600,239482,791255,739906,513011,903684,612331,139712,477159,891901,609220,264807,740911,432345,304906,91538,227102,164569,897089,343443,156636,716113,511797,585769,735782,527925,962566,621099,615329,909076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]