SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280820 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280820 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478374,922119,359979,1009004,203492,649830,913880,1040106,825036,223501,257386,459731,331019,315469,769990,845427,1021098,398373,591040,1021886,636947,130087,2899,482661,479243,963675,602177,378327,1035771,963710,532493,474134,448163,178535,551303,357297,553661,858201,732697,554946,60710,350563,580551,1040362,106112,1041614,150,1001197,301891,473111,64125,310435,350131,876511,798852,145382,571695,1015920,247914,237176) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002879s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]