SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681463 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681463 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578032,25091,341089,146245,1009328,95838,965520,624780,188309,676503,668348,620779,790374,329201,356580,590846,606963,68382,488442,609010,424443,229936,315482,249208,356058,1033496,188720,28447,989237,561720,773010,15944,190831,579733,213581,536232,484333,810739,746469,659848,461765,501138,993056,315082,446584,88420,971057,406834,36799,758901,227245,807431,138901,850405,794577,58363,592210,872291,746105,984441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]