SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149800 LIMIT 1 [ RunTime:0.002005s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149800 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337989,525954,313129,807114,224313,79592,831422,494750,220253,622750,655490,880827,616286,429093,384808,988738,199606,1008176,473217,96992,818275,882554,93381,982897,345163,775382,162217,185054,464997,993287,379798,411967,446308,294307,208405,932703,342622,351445,1025848,646905,471795,548431,651641,265543,274209,85728,99308,678295,379125,77579,261512,453827,910094,689760,57915,990074,659837,898663,597044,104595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000810s ]