SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 622911 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 622911 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480028,889827,949383,313799,430622,525507,220072,349125,1012473,298295,727370,39683,193272,867986,796757,57212,274663,797890,780389,233948,466548,848120,668860,38241,256943,824787,928504,91379,184823,374080,503410,1045333,816771,298746,69799,689567,278125,36496,892826,590246,102432,833601,368353,956370,348925,261005,180730,404163,981351,369098,220853,99100,1035423,38059,838650,374572,945239,498831,307144,861392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 622911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 622911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]