SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047684 LIMIT 1 [ RunTime:0.004239s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047684 [ RunTime:0.003102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657948,88680,835500,106406,680366,121335,940381,554197,582291,372725,298624,264932,7731,134812,977099,571462,167608,285343,953426,34635,994328,745640,827219,57921,832191,298625,218092,326485,350925,666962,803431,249526,507963,415192,355045,835560,285488,843981,677608,936271,593313,735541,197034,17012,734306,41177,321884,687460,80430,539063,1024679,621540,260958,737326,290408,890068,131075,865831,865348,717259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]