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` = 475412 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475412 [ RunTime:0.005772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853199,427804,397920,395708,936107,353360,810777,722768,705306,1046839,31127,518968,660611,15782,145206,402157,96601,105089,340122,263454,566127,425063,1010172,485192,508514,201395,1035815,867326,305495,191971,612231,688282,356067,603610,621968,147983,1031708,849735,506995,701951,623684,795267,586309,88049,272627,942515,974141,19716,1047082,641879,776735,603088,626245,189130,159500,312923,336869,338023,469288,596619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]