SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592180 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592180 [ RunTime:0.004988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828339,1013098,885455,1030968,231573,925364,123799,384263,667060,566055,246079,1022345,695407,640067,57697,892965,986449,670742,349108,975900,671653,355739,191076,1004470,218048,19155,912799,666065,961591,105083,696440,800068,645396,970820,183472,175420,776640,154680,125121,825985,615819,592243,980434,439734,57479,325993,83032,861674,705870,370856,621960,110367,948789,5425,55276,530782,424855,518951,542226,216479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]