SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441329 LIMIT 1 [ RunTime:0.000708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441329 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717741,467203,989885,518546,907340,142232,627865,627225,567226,165016,452169,541010,1026759,17049,585413,664410,356272,701385,1006690,404723,557920,557020,149393,1017563,60616,372415,498417,918768,770081,826066,217650,293093,162741,249906,89823,19283,788873,878795,1043182,507211,411255,468885,344943,455930,366738,980944,364550,895980,974738,642338,346525,697854,797881,586764,172513,911197,992563,269218,866315,618085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]