SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511791 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511791 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180893,335420,203905,784707,58141,21796,1015265,915600,545525,412595,708030,386363,964889,217200,453747,986996,1048700,1047210,965070,202280,161721,40108,527866,914645,348781,900363,80850,379854,822305,551997,678110,805341,16345,642592,772288,1028263,278236,594554,622502,110068,797491,249957,312938,246293,975421,252612,51056,800196,904957,757774,664195,154182,581994,1043027,806526,631797,262031,840677,711126,810004) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]