SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413285 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413285 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194293,73705,257822,847301,895547,579586,419451,355551,466179,985180,113091,105227,11727,226542,577273,36339,655738,36248,859797,649287,481379,829199,1012650,777425,706366,159163,441993,841880,910948,738521,942369,200426,150048,584323,957896,584046,1036177,818968,20679,579666,55061,267068,636960,462651,329128,1017505,512928,51667,16409,923256,868342,1036067,1000852,72203,760310,961885,811456,389926,672608,545919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]