SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046161 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046161 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313201,818780,814496,233776,95770,575457,1823,1035043,935728,482053,855850,931262,511149,104674,896605,123389,630569,575115,375566,223681,327451,570559,38829,238118,1020858,594445,568133,670417,742484,697467,330051,513742,371917,898958,754963,522108,511639,287222,910916,551020,170796,502753,9806,245389,166751,45840,510902,195693,744973,902244,413287,125856,569701,755131,940009,861599,711807,20234,55311,447875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]