SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001996s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028540 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028540 [ RunTime:0.006952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417414,491132,850421,611600,406682,903982,200209,155255,767650,285136,768615,422224,418399,151240,785210,705104,15563,750169,290302,51757,432380,327165,251081,545551,660993,1012426,994906,809085,579306,123061,244527,979961,506746,1015852,113503,1026663,775998,138581,300565,562112,921909,822177,705552,1030996,391817,422036,947003,182592,870356,537986,721584,447278,382652,266019,415606,224897,825686,264385,333471,886359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]