SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445909 LIMIT 1 [ RunTime:0.001947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445909 [ RunTime:0.001428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984849,884838,1009666,455581,936446,982475,839295,78498,265160,358148,775294,865366,529402,345986,739773,601154,2902,322773,515152,443686,720684,160099,129479,246620,420962,776478,821701,1017212,981140,777006,13429,516299,322666,507433,1025827,203130,698078,101107,20806,729547,125289,145878,533262,246522,566037,506315,768490,467141,1025938,139441,571215,637764,388076,880674,788799,318639,851272,124963,162882,747559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004562s ]