SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682523 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682523 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989024,369096,238733,238269,910678,810329,276345,885859,74251,488319,456850,783876,566470,723352,533196,699686,208783,558374,127317,241061,43255,175794,249823,982911,219576,1042857,895355,327776,1027298,456177,676853,539994,698270,583718,306638,836555,314415,660311,393193,225787,241060,295655,1048839,410099,500213,705649,844288,567815,40599,450418,182545,526807,507447,113321,25333,421271,900071,807622,234130,27840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]