SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199783 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199783 [ RunTime:0.006044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703359,254362,362399,552249,635210,940897,593683,149866,270901,723082,562040,911272,372002,463109,62704,239354,166858,331883,1015876,562043,52240,536982,276712,684052,392587,808812,683150,170069,791696,118854,764788,773035,14086,211224,1044535,500163,289956,107233,544535,50615,567207,255454,385354,201311,976030,640191,134311,668969,124693,687796,660174,83278,694015,458051,969665,165358,230893,725255,724985,90033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000993s ]