SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159313 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159313 [ RunTime:0.002635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517545,275851,194456,722042,704261,224390,313149,828345,218944,756678,126384,941783,400317,565545,295958,1039868,780676,339735,855180,758988,506079,250639,702627,545243,472424,556581,371470,467723,262576,224134,202317,987749,760494,333459,510856,284633,437238,277023,233568,653114,834031,325252,89790,656201,286519,754482,206861,489332,778268,479548,469942,162812,449817,117785,157412,902581,750488,117054,975734,875902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]