SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014990 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014990 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412194,289134,690723,974496,686611,154490,258157,493364,70105,833375,58568,284448,424162,531583,887618,724952,929820,701908,480685,478902,469672,602619,738430,9342,395805,1020411,477107,808307,362653,864031,239230,882212,74668,760994,783150,652474,92039,378601,373476,1006164,514652,330075,280431,929799,149237,223430,277993,869587,580467,570855,107894,475000,407922,270005,313201,662357,3557,48810,114449,246541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]