SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016770 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016770 [ RunTime:0.003477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202221,173301,929880,789827,534672,396133,742373,612503,1020935,290027,704759,476163,631930,212506,521547,587317,757767,211300,711420,403813,595548,526026,435150,883874,273012,1010215,217115,342364,1040923,93194,450207,528459,844568,1012260,876567,521916,946413,190,664119,590050,961738,277134,841707,420958,875935,883870,220868,1028278,698157,826382,641284,244099,453272,132981,901712,389316,285253,731744,952406,347258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001090s ]