SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305520 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305520 [ RunTime:0.002953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484216,601112,504329,393103,623490,682311,670217,643493,245544,484426,815171,852102,359947,629860,891861,920092,625315,936299,163129,285346,959088,23663,485999,494164,794027,390762,354221,595945,379524,399867,89432,9663,693060,801892,767421,979088,79049,502351,187780,1023568,29068,1007423,828483,545489,285434,279943,238363,172905,892934,931857,10080,308900,977886,542553,735655,714393,391380,729908,211900,945797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]