SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026512 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026512 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380385,730310,223456,837009,288056,546434,680128,751997,453834,578976,956549,654261,631168,744053,1046499,300125,319688,498079,731300,262470,932698,736855,539440,132517,87199,485277,40560,844267,135146,291792,99845,518171,529355,924718,341522,151648,2249,773830,270227,96784,970552,382824,974224,765744,686339,629251,760537,830263,895941,22185,710568,312068,293337,239264,967543,435842,264428,1031359,459056,203754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]