SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36643 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36643 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728981,666383,134205,213411,358078,119983,504381,873017,696476,335539,232885,28910,390196,363516,102286,341222,1845,462410,256340,458894,1039028,505738,848355,774700,335078,39338,648625,1012829,1014244,121548,57169,72071,444697,8002,928208,493918,384431,970408,306470,1011736,330188,473563,872615,94370,219315,300445,386367,68926,862200,122668,988210,41539,183986,706649,538538,911875,234050,337253,779222,898012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]