SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520123 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520123 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510137,423521,1010976,37480,550796,461635,356636,217900,48682,169765,286934,251512,201963,684297,195067,848015,736546,34167,744504,276292,323918,683726,258528,420096,101001,811385,213543,488983,562085,339,556813,458444,141144,389754,319325,755319,271756,602983,512710,130097,266540,551877,633695,800794,190081,299017,79328,277613,202837,892745,278321,810272,538100,847561,277935,919975,477808,540375,622856,415970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520123 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520123 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]