SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488585 LIMIT 1 [ RunTime:0.004481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488585 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333088,726764,704227,640588,435239,795809,94353,632635,641658,984880,538120,1004075,36688,249605,417779,444310,293926,1011940,973449,407211,814908,709187,523836,329529,629739,114009,583886,759936,635978,546453,706975,760211,277409,526126,1006348,759117,426273,57466,588394,1031862,342884,372497,300572,1975,424631,869731,19349,427253,260875,384474,426069,751572,1001856,411886,159815,994056,35701,190406,448668,877712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]