SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009816 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009816 [ RunTime:0.002920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420342,1040917,188066,850158,484599,937690,526836,188915,42254,936963,669307,27498,676398,422045,895709,1013650,118612,933314,10199,422117,248295,470383,1042749,667064,473920,480103,761608,409705,769061,374351,125385,344445,59533,176991,559711,532163,188901,681329,1029185,315446,190882,931077,702209,932471,853393,627752,431245,689133,686866,361283,18926,761501,716973,904067,636628,238332,150350,552009,595319,684030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000793s ]