SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211392 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211392 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417227,368934,802114,104042,179682,793678,631520,898302,296561,783443,702049,338532,411964,555199,163865,810418,113678,984713,119284,206043,953591,314043,239568,485221,365385,295890,44139,258181,353557,788882,889810,614831,251097,476115,1048909,859228,126349,334875,598969,352652,400472,401445,647655,481784,904869,282683,418872,822604,348939,682367,142616,795399,630034,626890,299554,117134,919430,893841,244186,98470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]