SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594908 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594908 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217857,532778,493150,44195,910341,769644,753427,600601,591713,913859,57289,653643,462212,77915,187418,921412,360225,413200,421796,99241,34319,335619,344280,589417,420577,104965,858703,484604,872476,824822,653853,882016,296039,687685,582748,912586,418811,725549,395212,296520,1028429,434698,964223,722602,364485,258844,246013,87300,547387,579411,301659,54648,95215,1041003,832428,530719,318316,763054,387542,403622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]