SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342077 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342077 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826944,436225,962871,569144,1048095,866298,409311,268674,753459,222491,787030,253225,499830,831346,271806,491089,798208,135100,215898,795221,334166,201695,81520,804431,237364,87087,649410,987862,59137,961182,665518,425445,533624,147613,307439,92015,825614,458143,823637,882450,150203,178880,847566,158187,235793,926512,446357,931849,879125,960760,785380,338948,872831,880839,439020,197558,122150,723227,891684,571875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]