SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473801 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473801 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901916,310289,741765,398145,766206,972447,994377,758540,204889,986086,353819,759828,78505,780950,882928,438830,418838,196000,324684,349422,894042,813870,990385,453114,355117,281442,1002898,286492,856552,211211,356645,767245,268626,1021797,254658,239175,231497,80386,618728,113973,640822,726587,418009,330109,298543,220449,959794,819299,711363,501522,855294,697772,961907,926041,332206,766860,73348,857427,486041,853052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001226s ]