SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802426 LIMIT 1 [ RunTime:0.001180s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802426 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701516,1011485,805730,107054,451415,167245,874681,793239,159801,1046647,255135,320428,630016,821268,419909,612573,123377,186258,381364,683669,944607,555661,159201,38769,702681,1004357,266800,81529,407723,920795,420208,206194,57766,809327,882665,214282,620543,242676,502702,684940,903021,131748,715814,1025159,554424,829909,992583,914212,60175,124019,369941,264169,193605,822079,1009968,493322,41433,771817,650469,1007688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002804s ]