SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145416 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145416 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551787,251994,131467,199973,495042,84619,673741,242602,979997,934692,85747,729797,515708,165395,470712,808443,188756,955415,139075,1033389,489575,891345,1015823,615730,349458,756869,983432,835569,771997,12649,306745,951284,895280,190243,564333,205056,516795,244239,353963,46622,841107,952996,253584,488122,105931,280412,321408,912148,651683,858102,656496,269441,543670,133666,208137,920632,171796,17048,1024371,248149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002508s ]