SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2018 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2018 [ RunTime:0.004014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366377,572331,612308,657036,526434,370502,273783,613743,194120,1038256,336921,141354,349282,371031,623475,424085,301119,529267,628373,379213,906226,154508,276397,665087,353604,513410,420372,684041,728561,25536,377539,657231,14931,504800,701252,1023496,107965,19792,423773,843787,21349,667324,106684,418308,521000,11950,796094,571370,223033,884591,500480,999146,1034376,484647,768881,117937,590124,686818,650368,354092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002877s ]