SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520458 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520458 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654071,275265,118998,476798,534050,780457,847940,328031,946250,1021927,563936,94284,938449,843,449305,583064,783769,514610,666175,952197,659207,946831,824237,177965,519627,663081,525044,357313,1001716,804201,414386,404618,515608,522777,93680,660760,259763,533234,1031194,30296,921823,1032750,981623,749217,491881,794375,559871,239716,749846,8503,672864,978519,726374,94335,748478,229391,649663,251093,936110,598445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004625s ]