SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542266 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542266 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78108,969512,597528,789560,1030966,336709,817826,890308,503508,242096,578632,453309,748281,238309,778203,326867,959999,668567,48232,376455,679114,336361,227497,137035,967879,320914,184138,100878,923865,707527,559920,624386,950792,399000,536419,749457,418691,389180,109816,859602,550398,254182,331978,658182,1012505,569227,445748,294315,371685,1001734,984361,481689,984750,205943,275694,730833,953387,87915,720210,519512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]