SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012522 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012522 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924209,704901,543716,1011221,333131,580702,680054,419202,881169,310220,671504,174528,101843,607521,643328,755843,222281,158643,557142,801567,174807,535902,296743,237695,130536,213911,188175,804666,434958,414116,762137,732417,253172,684288,191765,927598,388257,644738,852791,178794,311465,855882,676894,169415,491093,267906,765164,709496,84120,44838,949306,351303,973720,396327,563952,590358,703365,925508,505566,518441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]