SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430517 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430517 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000726,556814,544090,81375,321970,716295,728649,753002,14193,458113,658209,908122,403376,906544,189454,538231,919341,863408,255562,260402,57390,990108,847036,929297,952185,423618,883371,308927,873166,338986,743986,53154,647012,973752,553719,63556,521241,646540,843675,151209,929377,765142,390096,862853,440730,198333,387225,794570,944037,639465,286064,980829,232024,145563,464932,126983,976937,82323,412899,701307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]