SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 234800 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 234800 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741904,435390,740157,189688,1008648,618016,518154,890412,518021,825293,59928,744241,208922,719222,338848,702435,435697,949121,762969,390854,54900,852324,533814,1047426,297399,633025,295938,796774,603070,110602,770183,734628,736289,699960,680967,678481,1001987,459941,509033,1019309,655495,795776,242359,946347,718882,882609,869491,219508,191192,726380,738733,61550,825120,993904,707462,21088,142003,915259,502653,403515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 234800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 234800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]