SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406074 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406074 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031675,493652,935529,4578,980855,506249,801001,680883,802084,487340,568730,151463,603979,57263,914479,116579,118871,373691,439217,259190,724184,666332,258227,251310,9555,886849,432632,690560,402727,770343,290306,519537,201847,930107,552085,274580,1037353,186756,786367,272769,504548,491135,941820,57536,591768,508248,65706,432574,661121,34390,955924,986291,10368,666636,1020749,696257,707275,589350,254447,855457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]