SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517781 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517781 [ RunTime:0.002916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346924,577457,309762,968180,852812,740884,896362,245858,276851,32417,417205,897610,240841,397514,102062,353178,534775,459411,596479,686376,437708,186600,747268,101624,392592,895682,82005,152897,511446,996592,132235,954872,111297,604344,593362,715368,985188,705389,745933,698274,419672,735408,648790,238901,589045,742428,895978,927853,566515,655379,970336,186187,695328,142985,160738,669399,240088,38307,114000,241493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]