SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002986s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486253 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486253 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937996,126258,642717,396982,261206,159855,600650,915189,1037917,1000240,85639,350296,938573,946198,934850,952236,81945,52969,200087,196441,306281,248080,812862,348917,390346,935020,621611,224551,816176,130302,27157,895548,238677,700668,354362,288252,229638,154877,520720,599174,829275,810763,116300,518211,748592,607095,83541,734703,824160,90100,86134,448343,62260,467335,208766,1048614,882396,547147,526350,808138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001848s ]