SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452951 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452951 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950146,526345,660795,784014,500199,1019988,571406,111101,711048,282947,923151,921025,809708,679612,146871,123074,322781,758399,778317,329667,637355,855997,903809,246975,209427,587222,117340,363058,1002739,794473,557199,190522,927275,809579,30416,146225,217019,908228,524635,47128,890376,880809,411957,668471,245496,948552,768021,392830,98922,164711,145385,992877,1039475,729703,659298,748300,862263,477596,933793,804982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]