SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269543 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269543 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682932,973209,239697,253598,502963,761022,58574,472881,560528,551437,104877,962270,688101,172516,861909,307355,282201,543388,195061,798691,351343,730156,178481,754379,714727,90491,409066,14050,655280,990829,13523,254507,449613,760930,697326,625434,681196,149782,338459,659183,394665,918326,991066,494811,386161,351533,620411,434394,387488,1024215,259481,324214,990197,487620,221795,296765,659343,261249,452823,342083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]