SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80451 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80451 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384989,752216,259390,866163,854676,93001,113987,431259,527155,622117,116832,1045089,193515,866869,675670,813666,555646,890471,725474,634305,837700,472612,979129,928257,317064,155382,300206,102848,542394,795034,297932,935492,240541,63557,563662,820817,389357,830587,511129,544477,885274,1041212,700441,1017473,927249,919610,1012318,144127,555655,674724,801400,563457,684720,825116,629452,735225,896618,340372,203308,302533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002880s ]