SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021183 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021183 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998741,92541,494628,30804,150433,743898,831373,405312,642659,329285,1006667,803934,550842,993460,81498,30133,801345,844,880886,103190,704983,551587,435498,785969,1043665,220442,540720,529523,762265,316759,286580,786291,762599,15475,601019,53378,805484,41070,43415,789213,67278,13461,48902,656304,216736,463658,462019,281987,857011,461572,652564,540835,307574,427295,5559,493672,263966,578395,476137,648975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]