SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 914013 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 914013 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421201,826259,852762,27169,634411,911757,114790,165817,864999,823402,375313,433031,960103,465402,21910,418317,400941,556496,829279,439544,187919,91477,17020,954101,777259,270747,396197,488526,61707,781086,144515,229528,904515,829381,752180,757710,635884,42681,466492,502157,833758,825702,137852,840886,572219,93601,78032,3439,776270,801741,828007,297384,361479,997567,738142,129259,1377,768687,53878,624391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 914013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 914013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]