SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502115 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502115 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219381,110584,777565,339618,164503,229361,132248,8418,630327,118744,608744,778454,233688,405947,163201,185217,216799,554241,323568,1002639,534073,709309,289243,1024747,791960,666115,330499,256300,363397,173766,771752,577447,226201,402526,5300,771561,888117,586944,268991,1019474,347126,262441,866642,292467,613641,980274,514278,270476,446373,91210,339705,285930,165088,979767,745463,387121,936225,37381,450421,416187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001038s ]