SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435216 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435216 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554783,937204,295604,306633,816541,790743,1034059,400378,898493,698663,336747,472645,35466,616667,142471,674558,1009943,484203,244789,670180,779798,1005341,891760,128224,171606,465846,873942,872839,885607,496414,797553,450384,241322,106903,78490,949750,182040,349434,269205,644861,225571,737248,842116,867443,240652,654776,739686,765204,736418,997850,590472,1028980,431091,890560,869271,788733,132432,614551,396772,610547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]