SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 968301 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 968301 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627093,368565,610489,1034791,220035,758250,572237,814194,346642,664919,263632,1031492,952996,902663,508411,837383,910062,48212,956487,596184,166868,989031,537489,571200,108232,391,601160,470787,544258,828172,369040,656111,941003,953020,211847,376098,75507,430946,313129,748528,536730,981876,109457,61384,829163,821250,494209,372429,961743,105653,17768,9206,483250,932750,187270,677240,917046,706192,283191,324883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 968301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 968301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]