SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506443 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506443 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384680,886804,198272,463381,369029,884345,619809,737030,894441,551653,581334,626225,780937,483445,1034629,227320,949517,988129,860432,572299,582447,841486,544879,943606,980153,560977,55758,221354,121491,987605,934606,211179,74595,13597,270323,24063,440375,989561,696050,633780,684300,833432,274693,331332,143064,616557,109302,290772,314695,334911,586274,392236,374547,951851,779650,751271,333782,14673,252774,706935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]