SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 954311 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 954311 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101184,594988,205979,150959,99455,288424,45071,540771,508494,525256,373028,895710,968253,376190,291179,1018310,603035,954952,760345,82093,21326,744738,311658,673952,658255,634945,255255,83699,740750,972143,2261,946793,722254,70738,664468,330548,582349,388129,26772,95222,534566,584388,471072,807803,20158,287154,193215,927146,1000055,974885,340179,724667,757319,597431,344871,465108,244016,532251,733333,152406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 954311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 954311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]