SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019906 LIMIT 1 [ RunTime:0.002244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019906 [ RunTime:0.001225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266265,428637,1015534,365136,23313,317648,183680,57245,932719,157391,529387,124612,414694,637026,42852,222697,140348,989471,947319,361277,453464,511647,962610,795198,999761,506198,240347,386587,342481,583101,504774,306247,1020708,180808,652669,438393,939060,550525,996717,589437,664669,349750,134705,50631,145596,836248,220901,577706,715290,76964,544408,274967,49332,667292,1016020,456173,574689,391918,468771,568665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]