SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527013 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527013 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153981,251398,860081,279026,930138,45044,489532,981479,49416,198082,975453,145205,873416,39287,658075,55394,10030,84054,817993,264598,964497,456294,565992,869668,806044,515458,822651,1033945,152514,577608,766058,1037034,388418,838588,253124,526756,928311,215063,172928,567453,975950,872609,561568,154181,576135,1013576,466386,285084,502142,962531,70470,136126,576819,516901,1030618,982595,11151,791754,234892,179609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]