SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26187 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26187 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529087,418625,656024,372106,126021,377195,536635,1043010,542339,1018540,705495,190993,533552,781801,237625,247585,889054,338736,283349,901892,632780,547391,816586,379221,255442,116315,85829,73642,694884,192035,309123,926478,317771,406045,496338,547879,18555,446956,1044617,468099,505269,512476,463448,49198,419194,700710,155315,865375,1016870,476253,875423,994256,488464,340373,40501,801804,198829,389707,959995,622805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000363s ]