SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468316 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468316 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848404,871962,6088,231276,715843,906463,387295,374827,393697,35763,800908,992511,322166,285861,649968,660412,233808,815328,853525,984498,810320,172873,90186,560385,692889,696081,806115,801297,968132,910348,541683,74125,112274,392139,90152,101223,747409,179587,880598,446981,908032,455947,760401,979078,993338,277054,519981,534165,698455,649169,858409,641523,638424,493826,378643,512399,524916,481375,130887,1034655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]