SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582091 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582091 [ RunTime:0.002633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188624,850423,485865,61714,569491,297801,255873,605674,151891,34163,767123,666158,176622,420650,1042289,916813,687262,657740,211452,228764,420380,679256,270498,508010,442236,494580,321144,228399,441036,328825,545892,137410,817988,844938,766774,270953,391729,174327,794892,286848,719526,107166,930936,1005038,386665,697367,886010,928389,753675,324205,203754,950561,637975,793428,586765,855644,310330,136325,28412,968068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]