SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436628 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436628 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277589,42595,208930,617543,1002409,53339,86772,938722,301267,336133,725074,307826,611962,767381,551082,526544,798830,836443,211229,634083,670698,254762,953852,768121,296313,969472,112340,1017317,1021686,167737,468422,591382,741775,838297,20924,16928,28749,370888,45717,398715,193822,772987,651343,766147,68106,69096,1011023,311794,265181,309453,243250,476406,882813,677261,798057,968575,520426,906304,362422,648849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]