SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261811 LIMIT 1 [ RunTime:0.004065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261811 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498620,653931,198435,786966,1033589,183216,463059,468300,760428,997145,607705,117165,419377,728316,500812,368936,78593,168867,567194,4924,340908,692613,293423,548432,716098,193129,306443,1043744,319897,683011,179897,49448,262003,716939,879287,25414,239184,23314,750467,560952,442958,912774,892502,342413,298741,1016186,787791,533422,803878,869934,831985,134058,786894,581628,977682,921872,869642,184645,724119,743488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002138s ]