SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480958 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480958 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9543,106533,252244,918206,604159,94258,232192,206612,836111,512730,30386,796274,480464,441275,703309,1280,844294,957802,971240,498015,699327,162696,918712,283324,906008,762738,937428,593758,580601,72639,761012,911596,952145,202750,257886,365,211002,1010766,353223,115091,535687,976345,825372,74458,426643,653649,351097,775004,86390,538125,592086,590610,909595,776948,427583,895836,968968,46021,341920,789747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]